Jason Duryea
Jason Duryea
Reactions
-
Re: Conditional Formatting When Multiple Values Are Selected
With multi-value columns, you may need to try using CONTAINS, instead of EQUALS.1 · -
Re: How to combine two formulas
If the Health Status is "C" you would need to base the formula on a non-variable date like Finish Date. For example: =IF([Health Status]@row = C, [Start Date]@row - [Finish Date]@row, [Star…1 · -
Re: Are you a PMO Org and have recently implemented control center?
The IT PMO that I work in implemented CC back late 2019 and overall the experience has been fantastic. You will need a super user to help maintain the projects and related templates. While CC has Glo…1 · -
Re: Formulas within conditional formatting?
I don't believe this is possible without using a helper column to determine if the On Hand amount is less than PAR. This could be a Yes/No value, then use this column to set the conditional formattin…1 · -
Re: Basic question on COUNT formula
You could create a helper column called "Level" with a column formula as shown below. Then count the rows where Level equals 0. =COUNT(ANCESTORS())1 ·
